package cn.hxth.cloud.api.mapper;


import cn.hxth.cloud.api.domain.OrderInfoItem;
import cn.hxth.cloud.api.tk.mapper.MyMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderInfoItemMapper extends MyMapper<OrderInfoItem> {
    @Select("SELECT id FROM order_info WHERE id NOT IN (SELECT DISTINCT oid FROM product ,order_info_item item WHERE item.pid=product.id AND item.count>inventory-locked_inventory) AND status=1")
    public List<Long> findOid() ;
}